Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 7728394 |
| Missing cells | 1611702 |
| Missing cells (%) | 0.9% |
| Duplicate rows | 153572 |
| Duplicate rows (%) | 2.0% |
| Total size in memory | 832.9 MiB |
| Average record size in memory | 113.0 B |
Variable types
| Categorical | 3 |
|---|---|
| Numeric | 7 |
| Text | 3 |
| Boolean | 9 |
| Dataset has 153572 (2.0%) duplicate rows | Duplicates |
Severity is highly imbalanced (55.4%) | Imbalance |
Amenity is highly imbalanced (90.3%) | Imbalance |
Give_Way is highly imbalanced (95.7%) | Imbalance |
Junction is highly imbalanced (62.0%) | Imbalance |
No_Exit is highly imbalanced (97.5%) | Imbalance |
Railway is highly imbalanced (92.8%) | Imbalance |
Stop is highly imbalanced (81.7%) | Imbalance |
Traffic_Calming is highly imbalanced (98.9%) | Imbalance |
Temperature(F) has 163853 (2.1%) missing values | Missing |
Humidity(%) has 174144 (2.3%) missing values | Missing |
Pressure(in) has 140679 (1.8%) missing values | Missing |
Visibility(mi) has 177098 (2.3%) missing values | Missing |
Wind_Direction has 175206 (2.3%) missing values | Missing |
Wind_Speed(mph) has 571233 (7.4%) missing values | Missing |
Weather_Condition has 173459 (2.2%) missing values | Missing |
Distance(mi) is highly skewed (γ1 = 20.38575876) | Skewed |
Duration_Seconds is highly skewed (γ1 = 50.63729121) | Skewed |
Distance(mi) has 3302161 (42.7%) zeros | Zeros |
Wind_Speed(mph) has 961643 (12.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-04 23:29:24.880102 |
|---|---|
| Analysis finished | 2024-11-04 23:33:17.018279 |
| Duration | 3 minutes and 52.14 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Severity
Categorical
Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 59.0 MiB |
| 2 | |
|---|---|
| 3 | |
| 4 | 204710 |
| 1 | 67366 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 3 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 6156981 | |
| 3 | 1299337 | 16.8% |
| 4 | 204710 | 2.6% |
| 1 | 67366 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 6156981 | |
| 3 | 1299337 | 16.8% |
| 4 | 204710 | 2.6% |
| 1 | 67366 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 6156981 | |
| 3 | 1299337 | 16.8% |
| 4 | 204710 | 2.6% |
| 1 | 67366 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7728394 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 6156981 | |
| 3 | 1299337 | 16.8% |
| 4 | 204710 | 2.6% |
| 1 | 67366 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7728394 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 6156981 | |
| 3 | 1299337 | 16.8% |
| 4 | 204710 | 2.6% |
| 1 | 67366 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7728394 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 6156981 | |
| 3 | 1299337 | 16.8% |
| 4 | 204710 | 2.6% |
| 1 | 67366 | 0.9% |
Distance(mi)
Real number (ℝ)
Skewed  Zeros 
| Distinct | 22382 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.56184228 |
| Minimum | 0 |
|---|---|
| Maximum | 441.75 |
| Zeros | 3302161 |
| Zeros (%) | 42.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 59.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.03 |
| Q3 | 0.464 |
| 95-th percentile | 2.67 |
| Maximum | 441.75 |
| Range | 441.75 |
| Interquartile range (IQR) | 0.464 |
Descriptive statistics
| Standard deviation | 1.7768106 |
|---|---|
| Coefficient of variation (CV) | 3.1624722 |
| Kurtosis | 1649.5954 |
| Mean | 0.56184228 |
| Median Absolute Deviation (MAD) | 0.03 |
| Skewness | 20.385759 |
| Sum | 4342138.5 |
| Variance | 3.1570559 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3302161 | |
| 0.01 | 262493 | 3.4% |
| 0.008 | 14558 | 0.2% |
| 0.009 | 13836 | 0.2% |
| 0.009999999776 | 13367 | 0.2% |
| 0.007 | 12413 | 0.2% |
| 0.011 | 11625 | 0.2% |
| 0.03 | 11322 | 0.1% |
| 0.024 | 11002 | 0.1% |
| 0.028 | 10927 | 0.1% |
| Other values (22372) | 4064690 |
| Value | Count | Frequency (%) |
| 0 | 3302161 | |
| 0.001 | 5585 | 0.1% |
| 0.002 | 3078 | < 0.1% |
| 0.003 | 4263 | 0.1% |
| 0.004 | 6337 | 0.1% |
| 0.005 | 8253 | 0.1% |
| 0.006 | 10121 | 0.1% |
| 0.007 | 12413 | 0.2% |
| 0.008 | 14558 | 0.2% |
| 0.009 | 13836 | 0.2% |
| Value | Count | Frequency (%) |
| 441.75 | 1 | |
| 336.5700073 | 1 | |
| 333.6300049 | 1 | |
| 254.3999939 | 1 | |
| 251.2200012 | 1 | |
| 242.3399963 | 1 | |
| 227.2100067 | 1 | |
| 224.5899963 | 1 | |
| 210.0800018 | 1 | |
| 194.7299957 | 1 |
Street
Text
| Distinct | 336306 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 10869 |
| Missing (%) | 0.1% |
| Memory size | 59.0 MiB |
Length
| Max length | 59 |
|---|---|
| Median length | 47 |
| Mean length | 11.062818 |
| Min length | 1 |
Unique
| Unique | 129934 ? |
|---|---|
| Unique (%) | 1.7% |
Sample
| 1st row | I-70 E |
|---|---|
| 2nd row | Brice Rd |
| 3rd row | State Route 32 |
| 4th row | I-75 S |
| 5th row | Miamisburg Centerville Rd |
| Value | Count | Frequency (%) |
| n | 1199552 | 6.3% |
| s | 1194304 | 6.2% |
| rd | 1159617 | 6.0% |
| w | 941905 | 4.9% |
| e | 931753 | 4.9% |
| st | 684198 | 3.6% |
| ave | 640512 | 3.3% |
| blvd | 343950 | 1.8% |
| fwy | 330007 | 1.7% |
| dr | 327207 | 1.7% |
| Other values (74656) | 11416775 |
Most occurring characters
| Value | Count | Frequency (%) |
| 13148775 | 15.4% | |
| e | 4752092 | 5.6% |
| a | 3818802 | 4.5% |
| r | 3231482 | 3.8% |
| t | 3213194 | 3.8% |
| o | 2990987 | 3.5% |
| S | 2982408 | 3.5% |
| n | 2968805 | 3.5% |
| d | 2778142 | 3.3% |
| l | 2764944 | 3.2% |
| Other values (70) | 42727942 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 85377573 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 13148775 | 15.4% | |
| e | 4752092 | 5.6% |
| a | 3818802 | 4.5% |
| r | 3231482 | 3.8% |
| t | 3213194 | 3.8% |
| o | 2990987 | 3.5% |
| S | 2982408 | 3.5% |
| n | 2968805 | 3.5% |
| d | 2778142 | 3.3% |
| l | 2764944 | 3.2% |
| Other values (70) | 42727942 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 85377573 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 13148775 | 15.4% | |
| e | 4752092 | 5.6% |
| a | 3818802 | 4.5% |
| r | 3231482 | 3.8% |
| t | 3213194 | 3.8% |
| o | 2990987 | 3.5% |
| S | 2982408 | 3.5% |
| n | 2968805 | 3.5% |
| d | 2778142 | 3.3% |
| l | 2764944 | 3.2% |
| Other values (70) | 42727942 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 85377573 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 13148775 | 15.4% | |
| e | 4752092 | 5.6% |
| a | 3818802 | 4.5% |
| r | 3231482 | 3.8% |
| t | 3213194 | 3.8% |
| o | 2990987 | 3.5% |
| S | 2982408 | 3.5% |
| n | 2968805 | 3.5% |
| d | 2778142 | 3.3% |
| l | 2764944 | 3.2% |
| Other values (70) | 42727942 |
Zipcode
Text
| Distinct | 825094 |
|---|---|
| Distinct (%) | 10.7% |
| Missing | 1915 |
| Missing (%) | < 0.1% |
| Memory size | 59.0 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 6.4678536 |
| Min length | 5 |
Unique
| Unique | 450606 ? |
|---|---|
| Unique (%) | 5.8% |
Sample
| 1st row | 45424 |
|---|---|
| 2nd row | 43068-3402 |
| 3rd row | 45176 |
| 4th row | 45417 |
| 5th row | 45459 |
| Value | Count | Frequency (%) |
| 91761 | 11247 | 0.1% |
| 91706 | 10022 | 0.1% |
| 92407 | 8922 | 0.1% |
| 92507 | 8850 | 0.1% |
| 33186 | 8375 | 0.1% |
| 32819 | 7461 | 0.1% |
| 91765 | 7377 | 0.1% |
| 33169 | 7106 | 0.1% |
| 90023 | 7066 | 0.1% |
| 92324 | 7010 | 0.1% |
| Other values (825084) | 7643043 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6303792 | |
| 2 | 6159301 | |
| 3 | 5704889 | |
| 1 | 5682170 | |
| 9 | 4463210 | |
| 7 | 4316166 | |
| 5 | 4183724 | |
| 4 | 4137052 | |
| 6 | 3427226 | |
| 8 | 3321903 | |
| Other values (3) | 2274302 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49973735 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6303792 | |
| 2 | 6159301 | |
| 3 | 5704889 | |
| 1 | 5682170 | |
| 9 | 4463210 | |
| 7 | 4316166 | |
| 5 | 4183724 | |
| 4 | 4137052 | |
| 6 | 3427226 | |
| 8 | 3321903 | |
| Other values (3) | 2274302 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49973735 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6303792 | |
| 2 | 6159301 | |
| 3 | 5704889 | |
| 1 | 5682170 | |
| 9 | 4463210 | |
| 7 | 4316166 | |
| 5 | 4183724 | |
| 4 | 4137052 | |
| 6 | 3427226 | |
| 8 | 3321903 | |
| Other values (3) | 2274302 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49973735 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6303792 | |
| 2 | 6159301 | |
| 3 | 5704889 | |
| 1 | 5682170 | |
| 9 | 4463210 | |
| 7 | 4316166 | |
| 5 | 4183724 | |
| 4 | 4137052 | |
| 6 | 3427226 | |
| 8 | 3321903 | |
| Other values (3) | 2274302 | 4.6% |
Temperature(F)
Real number (ℝ)
Missing 
| Distinct | 860 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 163853 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.663286 |
| Minimum | -89 |
|---|---|
| Maximum | 207 |
| Zeros | 2775 |
| Zeros (%) | < 0.1% |
| Negative | 19478 |
| Negative (%) | 0.3% |
| Memory size | 59.0 MiB |
Quantile statistics
| Minimum | -89 |
|---|---|
| 5-th percentile | 28 |
| Q1 | 49 |
| median | 64 |
| Q3 | 76 |
| 95-th percentile | 89 |
| Maximum | 207 |
| Range | 296 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 19.013653 |
|---|---|
| Coefficient of variation (CV) | 0.30834642 |
| Kurtosis | -0.0012691043 |
| Mean | 61.663286 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.513733 |
| Sum | 4.6645445 × 108 |
| Variance | 361.51901 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 77 | 170991 | 2.2% |
| 73 | 170898 | 2.2% |
| 68 | 163767 | 2.1% |
| 72 | 160498 | 2.1% |
| 75 | 158448 | 2.1% |
| 70 | 155568 | 2.0% |
| 63 | 149787 | 1.9% |
| 59 | 149017 | 1.9% |
| 64 | 148466 | 1.9% |
| 79 | 147140 | 1.9% |
| Other values (850) | 5989961 | |
| (Missing) | 163853 | 2.1% |
| Value | Count | Frequency (%) |
| -89 | 10 | |
| -77.8 | 11 | |
| -58 | 1 | < 0.1% |
| -50 | 1 | < 0.1% |
| -45 | 1 | < 0.1% |
| -44 | 1 | < 0.1% |
| -40 | 2 | < 0.1% |
| -38 | 3 | < 0.1% |
| -37 | 5 | |
| -36 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 207 | 3 | |
| 203 | 1 | < 0.1% |
| 196 | 5 | |
| 189 | 1 | < 0.1% |
| 174 | 2 | < 0.1% |
| 172 | 2 | < 0.1% |
| 170.6 | 1 | < 0.1% |
| 168.8 | 1 | < 0.1% |
| 167 | 1 | < 0.1% |
| 162 | 2 | < 0.1% |
Humidity(%)
Real number (ℝ)
Missing 
| Distinct | 100 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 174144 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.831041 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 59.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 48 |
| median | 67 |
| Q3 | 84 |
| 95-th percentile | 97 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 22.820968 |
|---|---|
| Coefficient of variation (CV) | 0.3520068 |
| Kurtosis | -0.7234553 |
| Mean | 64.831041 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -0.39484242 |
| Sum | 4.897499 × 108 |
| Variance | 520.79656 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 93 | 290345 | 3.8% |
| 100 | 286680 | 3.7% |
| 87 | 169582 | 2.2% |
| 90 | 166492 | 2.2% |
| 89 | 140593 | 1.8% |
| 96 | 134809 | 1.7% |
| 84 | 126652 | 1.6% |
| 81 | 126612 | 1.6% |
| 82 | 124386 | 1.6% |
| 86 | 121255 | 1.6% |
| Other values (90) | 5866844 | |
| (Missing) | 174144 | 2.3% |
| Value | Count | Frequency (%) |
| 1 | 49 | < 0.1% |
| 2 | 189 | < 0.1% |
| 3 | 670 | < 0.1% |
| 4 | 2167 | < 0.1% |
| 5 | 4113 | 0.1% |
| 6 | 6010 | |
| 7 | 8072 | |
| 8 | 9661 | |
| 9 | 11116 | |
| 10 | 13495 |
| Value | Count | Frequency (%) |
| 100 | 286680 | |
| 99 | 14262 | 0.2% |
| 98 | 6977 | 0.1% |
| 97 | 88156 | 1.1% |
| 96 | 134809 | |
| 95 | 9612 | 0.1% |
| 94 | 119009 | |
| 93 | 290345 | |
| 92 | 66899 | 0.9% |
| 91 | 37561 | 0.5% |
Pressure(in)
Real number (ℝ)
Missing 
| Distinct | 1144 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 140679 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.538986 |
| Minimum | 0 |
|---|---|
| Maximum | 58.63 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 59.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.98 |
| Q1 | 29.37 |
| median | 29.86 |
| Q3 | 30.03 |
| 95-th percentile | 30.26 |
| Maximum | 58.63 |
| Range | 58.63 |
| Interquartile range (IQR) | 0.66 |
Descriptive statistics
| Standard deviation | 1.0061898 |
|---|---|
| Coefficient of variation (CV) | 0.034063113 |
| Kurtosis | 21.841661 |
| Mean | 29.538986 |
| Median Absolute Deviation (MAD) | 0.24 |
| Skewness | -3.6387719 |
| Sum | 2.241334 × 108 |
| Variance | 1.0124179 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29.96 | 123289 | 1.6% |
| 29.99 | 121836 | 1.6% |
| 30.01 | 119735 | 1.5% |
| 29.94 | 119000 | 1.5% |
| 30.04 | 113905 | 1.5% |
| 29.97 | 112320 | 1.5% |
| 30.03 | 110898 | 1.4% |
| 29.91 | 110700 | 1.4% |
| 30 | 109999 | 1.4% |
| 29.95 | 109924 | 1.4% |
| Other values (1134) | 6436109 | |
| (Missing) | 140679 | 1.8% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.29 | 2 | < 0.1% |
| 0.3 | 6 | |
| 0.39 | 1 | < 0.1% |
| 2.98 | 1 | < 0.1% |
| 2.99 | 9 | |
| 3 | 2 | < 0.1% |
| 3.01 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 58.63 | 9 | |
| 58.39 | 2 | < 0.1% |
| 58.32 | 1 | < 0.1% |
| 58.13 | 1 | < 0.1% |
| 58.1 | 4 | |
| 58.04 | 3 | < 0.1% |
| 58.03 | 1 | < 0.1% |
| 57.74 | 1 | < 0.1% |
| 57.54 | 2 | < 0.1% |
| 56.54 | 2 | < 0.1% |
Visibility(mi)
Real number (ℝ)
Missing 
| Distinct | 92 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 177098 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0903764 |
| Minimum | 0 |
|---|---|
| Maximum | 140 |
| Zeros | 7679 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 59.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.5 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 140 |
| Range | 140 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.6883159 |
|---|---|
| Coefficient of variation (CV) | 0.29573208 |
| Kurtosis | 81.893919 |
| Mean | 9.0903764 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.3166628 |
| Sum | 68644123 |
| Variance | 7.2270425 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 6070231 | |
| 7 | 217027 | 2.8% |
| 9 | 188529 | 2.4% |
| 8 | 149975 | 1.9% |
| 5 | 144153 | 1.9% |
| 6 | 126586 | 1.6% |
| 2 | 121785 | 1.6% |
| 4 | 119770 | 1.5% |
| 3 | 117493 | 1.5% |
| 1 | 102557 | 1.3% |
| Other values (82) | 193190 | 2.5% |
| (Missing) | 177098 | 2.3% |
| Value | Count | Frequency (%) |
| 0 | 7679 | 0.1% |
| 0.06 | 323 | < 0.1% |
| 0.1 | 1287 | < 0.1% |
| 0.12 | 1775 | < 0.1% |
| 0.19 | 41 | < 0.1% |
| 0.2 | 12105 | |
| 0.25 | 27344 | |
| 0.31 | 4 | < 0.1% |
| 0.38 | 337 | < 0.1% |
| 0.4 | 98 | < 0.1% |
| Value | Count | Frequency (%) |
| 140 | 3 | < 0.1% |
| 130 | 1 | < 0.1% |
| 120 | 5 | < 0.1% |
| 111 | 3 | < 0.1% |
| 110 | 1 | < 0.1% |
| 105 | 1 | < 0.1% |
| 101 | 1 | < 0.1% |
| 100 | 47 | |
| 98 | 1 | < 0.1% |
| 90 | 13 | < 0.1% |
Wind_Direction
Categorical
Missing 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 175206 |
| Missing (%) | 2.3% |
| Memory size | 59.0 MiB |
| CALM | |
|---|---|
| S | 419989 |
| SSW | 384840 |
| W | 383913 |
| WNW | 378781 |
| Other values (19) |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 2.8361859 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Calm |
|---|---|
| 2nd row | Calm |
| 3rd row | SW |
| 4th row | SW |
| 5th row | SW |
Common Values
| Value | Count | Frequency (%) |
| CALM | 961624 | 12.4% |
| S | 419989 | 5.4% |
| SSW | 384840 | 5.0% |
| W | 383913 | 5.0% |
| WNW | 378781 | 4.9% |
| NW | 369352 | 4.8% |
| Calm | 368557 | 4.8% |
| SW | 364470 | 4.7% |
| WSW | 353806 | 4.6% |
| SSE | 349110 | 4.5% |
| Other values (14) | 3218746 |
Length
| Value | Count | Frequency (%) |
| calm | 1330181 | |
| s | 419989 | 5.6% |
| ssw | 384840 | 5.1% |
| w | 383913 | 5.1% |
| wnw | 378781 | 5.0% |
| nw | 369352 | 4.9% |
| sw | 364470 | 4.8% |
| wsw | 353806 | 4.7% |
| sse | 349110 | 4.6% |
| nnw | 333427 | 4.4% |
| Other values (13) | 2885319 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 3465927 | |
| S | 3346752 | |
| N | 2903258 | |
| E | 2593990 | |
| C | 1330181 | 6.2% |
| A | 1212190 | 5.7% |
| L | 961624 | 4.5% |
| M | 961624 | 4.5% |
| a | 700094 | 3.3% |
| t | 599056 | 2.8% |
| Other values (12) | 3347549 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21422245 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 3465927 | |
| S | 3346752 | |
| N | 2903258 | |
| E | 2593990 | |
| C | 1330181 | 6.2% |
| A | 1212190 | 5.7% |
| L | 961624 | 4.5% |
| M | 961624 | 4.5% |
| a | 700094 | 3.3% |
| t | 599056 | 2.8% |
| Other values (12) | 3347549 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21422245 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 3465927 | |
| S | 3346752 | |
| N | 2903258 | |
| E | 2593990 | |
| C | 1330181 | 6.2% |
| A | 1212190 | 5.7% |
| L | 961624 | 4.5% |
| M | 961624 | 4.5% |
| a | 700094 | 3.3% |
| t | 599056 | 2.8% |
| Other values (12) | 3347549 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21422245 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 3465927 | |
| S | 3346752 | |
| N | 2903258 | |
| E | 2593990 | |
| C | 1330181 | 6.2% |
| A | 1212190 | 5.7% |
| L | 961624 | 4.5% |
| M | 961624 | 4.5% |
| a | 700094 | 3.3% |
| t | 599056 | 2.8% |
| Other values (12) | 3347549 |
Wind_Speed(mph)
Real number (ℝ)
Missing  Zeros 
| Distinct | 184 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 571233 |
| Missing (%) | 7.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6854896 |
| Minimum | 0 |
|---|---|
| Maximum | 1087 |
| Zeros | 961643 |
| Zeros (%) | 12.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 59.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4.6 |
| median | 7 |
| Q3 | 10.4 |
| 95-th percentile | 17 |
| Maximum | 1087 |
| Range | 1087 |
| Interquartile range (IQR) | 5.8 |
Descriptive statistics
| Standard deviation | 5.4249834 |
|---|---|
| Coefficient of variation (CV) | 0.7058735 |
| Kurtosis | 1085.4752 |
| Mean | 7.6854896 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 8.0494761 |
| Sum | 55006286 |
| Variance | 29.430445 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 961643 | 12.4% |
| 5 | 534875 | 6.9% |
| 6 | 517199 | 6.7% |
| 3 | 514123 | 6.7% |
| 7 | 480904 | 6.2% |
| 8 | 432522 | 5.6% |
| 9 | 389161 | 5.0% |
| 10 | 324080 | 4.2% |
| 12 | 280269 | 3.6% |
| 4.6 | 217615 | 2.8% |
| Other values (174) | 2504770 | |
| (Missing) | 571233 | 7.4% |
| Value | Count | Frequency (%) |
| 0 | 961643 | |
| 1 | 195 | < 0.1% |
| 1.2 | 445 | < 0.1% |
| 2 | 451 | < 0.1% |
| 2.3 | 906 | < 0.1% |
| 3 | 514123 | |
| 3.5 | 203579 | 2.6% |
| 4.6 | 217615 | 2.8% |
| 5 | 534875 | |
| 5.8 | 216150 | 2.8% |
| Value | Count | Frequency (%) |
| 1087 | 1 | < 0.1% |
| 984 | 1 | < 0.1% |
| 822.8 | 7 | |
| 812 | 1 | < 0.1% |
| 703.1 | 2 | < 0.1% |
| 580 | 2 | < 0.1% |
| 518 | 2 | < 0.1% |
| 471.8 | 1 | < 0.1% |
| 328 | 1 | < 0.1% |
| 255 | 1 | < 0.1% |
Missing 
| Distinct | 144 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 173459 |
| Missing (%) | 2.2% |
| Memory size | 59.0 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 30 |
| Mean length | 7.6729617 |
| Min length | 3 |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Light Rain |
|---|---|
| 2nd row | Light Rain |
| 3rd row | Overcast |
| 4th row | Mostly Cloudy |
| 5th row | Mostly Cloudy |
| Value | Count | Frequency (%) |
| fair | 2596473 | |
| cloudy | 2576033 | |
| mostly | 1032703 | 9.9% |
| clear | 808743 | 7.7% |
| partly | 709213 | 6.8% |
| light | 545023 | 5.2% |
| rain | 509071 | 4.9% |
| overcast | 382866 | 3.7% |
| scattered | 204829 | 2.0% |
| clouds | 204829 | 2.0% |
| Other values (51) | 888209 | 8.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 5372144 | 9.3% |
| a | 5364570 | 9.3% |
| r | 4858585 | 8.4% |
| y | 4510118 | 7.8% |
| o | 4153193 | 7.2% |
| i | 3924138 | 6.8% |
| C | 3589627 | 6.2% |
| t | 3202474 | 5.5% |
| d | 3164721 | 5.5% |
| 2903057 | 5.0% | |
| Other values (36) | 16926100 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 57968727 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 5372144 | 9.3% |
| a | 5364570 | 9.3% |
| r | 4858585 | 8.4% |
| y | 4510118 | 7.8% |
| o | 4153193 | 7.2% |
| i | 3924138 | 6.8% |
| C | 3589627 | 6.2% |
| t | 3202474 | 5.5% |
| d | 3164721 | 5.5% |
| 2903057 | 5.0% | |
| Other values (36) | 16926100 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 57968727 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 5372144 | 9.3% |
| a | 5364570 | 9.3% |
| r | 4858585 | 8.4% |
| y | 4510118 | 7.8% |
| o | 4153193 | 7.2% |
| i | 3924138 | 6.8% |
| C | 3589627 | 6.2% |
| t | 3202474 | 5.5% |
| d | 3164721 | 5.5% |
| 2903057 | 5.0% | |
| Other values (36) | 16926100 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 57968727 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 5372144 | 9.3% |
| a | 5364570 | 9.3% |
| r | 4858585 | 8.4% |
| y | 4510118 | 7.8% |
| o | 4153193 | 7.2% |
| i | 3924138 | 6.8% |
| C | 3589627 | 6.2% |
| t | 3202474 | 5.5% |
| d | 3164721 | 5.5% |
| 2903057 | 5.0% | |
| Other values (36) | 16926100 |
Amenity
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True | 96334 |
| Value | Count | Frequency (%) |
| False | 7632060 | |
| True | 96334 | 1.2% |
| Value | Count | Frequency (%) |
| False | 6854631 | |
| True | 873763 | 11.3% |
Give_Way
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True | 36582 |
| Value | Count | Frequency (%) |
| False | 7691812 | |
| True | 36582 | 0.5% |
Junction
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True | 571342 |
| Value | Count | Frequency (%) |
| False | 7157052 | |
| True | 571342 | 7.4% |
No_Exit
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True | 19545 |
| Value | Count | Frequency (%) |
| False | 7708849 | |
| True | 19545 | 0.3% |
Railway
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True | 66979 |
| Value | Count | Frequency (%) |
| False | 7661415 | |
| True | 66979 | 0.9% |
Stop
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True | 214371 |
| Value | Count | Frequency (%) |
| False | 7514023 | |
| True | 214371 | 2.8% |
Traffic_Calming
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True | 7598 |
| Value | Count | Frequency (%) |
| False | 7720796 | |
| True | 7598 | 0.1% |
Traffic_Signal
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 6584622 | |
| True | 1143772 | 14.8% |
Civil_Twilight
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 23246 |
| Missing (%) | 0.3% |
| Memory size | 59.0 MiB |
| Day | |
|---|---|
| Night |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.5216069 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Night |
|---|---|
| 2nd row | Night |
| 3rd row | Night |
| 4th row | Day |
| 5th row | Day |
Common Values
| Value | Count | Frequency (%) |
| Day | 5695619 | |
| Night | 2009529 | 26.0% |
| (Missing) | 23246 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| day | 5695619 | |
| night | 2009529 | 26.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 5695619 | |
| a | 5695619 | |
| y | 5695619 | |
| N | 2009529 | 7.4% |
| i | 2009529 | 7.4% |
| g | 2009529 | 7.4% |
| h | 2009529 | 7.4% |
| t | 2009529 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 27134502 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| D | 5695619 | |
| a | 5695619 | |
| y | 5695619 | |
| N | 2009529 | 7.4% |
| i | 2009529 | 7.4% |
| g | 2009529 | 7.4% |
| h | 2009529 | 7.4% |
| t | 2009529 | 7.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 27134502 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| D | 5695619 | |
| a | 5695619 | |
| y | 5695619 | |
| N | 2009529 | 7.4% |
| i | 2009529 | 7.4% |
| g | 2009529 | 7.4% |
| h | 2009529 | 7.4% |
| t | 2009529 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 27134502 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| D | 5695619 | |
| a | 5695619 | |
| y | 5695619 | |
| N | 2009529 | 7.4% |
| i | 2009529 | 7.4% |
| g | 2009529 | 7.4% |
| h | 2009529 | 7.4% |
| t | 2009529 | 7.4% |
Duration_Seconds
Real number (ℝ)
Skewed 
| Distinct | 74455 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26665.257 |
| Minimum | 73 |
|---|---|
| Maximum | 1.6877634 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 59.0 MiB |
Quantile statistics
| Minimum | 73 |
|---|---|
| 5-th percentile | 1724 |
| Q1 | 1890 |
| median | 4490 |
| Q3 | 7509 |
| 95-th percentile | 21600 |
| Maximum | 1.6877634 × 108 |
| Range | 1.6877627 × 108 |
| Interquartile range (IQR) | 5619 |
Descriptive statistics
| Standard deviation | 810737.55 |
|---|---|
| Coefficient of variation (CV) | 30.404265 |
| Kurtosis | 3659.5997 |
| Mean | 26665.257 |
| Median Absolute Deviation (MAD) | 2700 |
| Skewness | 50.637291 |
| Sum | 2.0607962 × 1011 |
| Variance | 6.5729538 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 21600 | 369307 | 4.8% |
| 1800 | 116096 | 1.5% |
| 2700 | 70075 | 0.9% |
| 4500 | 61374 | 0.8% |
| 3600 | 61173 | 0.8% |
| 14400 | 57317 | 0.7% |
| 1785 | 56112 | 0.7% |
| 1786 | 55955 | 0.7% |
| 1787 | 55058 | 0.7% |
| 1784 | 54369 | 0.7% |
| Other values (74445) | 6771558 |
| Value | Count | Frequency (%) |
| 73 | 1 | < 0.1% |
| 115 | 1 | < 0.1% |
| 120 | 2 | < 0.1% |
| 150 | 3 | < 0.1% |
| 152 | 1 | < 0.1% |
| 180 | 16 | |
| 210 | 6 | < 0.1% |
| 221 | 1 | < 0.1% |
| 229 | 1 | < 0.1% |
| 240 | 14 |
| Value | Count | Frequency (%) |
| 168776340 | 2 | |
| 134184345 | 1 | < 0.1% |
| 134181332 | 3 | |
| 134179838 | 3 | |
| 134176830 | 2 | |
| 106135755 | 1 | < 0.1% |
| 100954757 | 1 | < 0.1% |
| 94755540 | 1 | < 0.1% |
| 94697995 | 1 | < 0.1% |
| 94697990 | 1 | < 0.1% |
Interactions
Correlations
| Amenity | Civil_Twilight | Crossing | Distance(mi) | Duration_Seconds | Give_Way | Humidity(%) | Junction | No_Exit | Pressure(in) | Railway | Severity | Stop | Temperature(F) | Traffic_Calming | Traffic_Signal | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amenity | 1.000 | 0.007 | 0.149 | 0.001 | 0.002 | 0.006 | 0.015 | 0.026 | 0.014 | 0.023 | 0.050 | 0.039 | 0.034 | 0.011 | 0.024 | 0.106 | 0.002 | 0.023 | 0.000 |
| Civil_Twilight | 0.007 | 1.000 | 0.040 | 0.003 | 0.007 | 0.005 | 0.242 | 0.016 | 0.005 | 0.030 | 0.000 | 0.055 | 0.001 | 0.264 | 0.000 | 0.045 | 0.016 | 0.181 | 0.001 |
| Crossing | 0.149 | 0.040 | 1.000 | 0.004 | 0.008 | 0.058 | 0.035 | 0.088 | 0.061 | 0.035 | 0.178 | 0.121 | 0.116 | 0.051 | 0.038 | 0.477 | 0.007 | 0.052 | 0.001 |
| Distance(mi) | 0.001 | 0.003 | 0.004 | 1.000 | 0.404 | 0.000 | -0.019 | 0.001 | 0.000 | -0.125 | 0.000 | 0.006 | 0.001 | -0.058 | 0.001 | 0.004 | -0.009 | 0.001 | -0.005 |
| Duration_Seconds | 0.002 | 0.007 | 0.008 | 0.404 | 1.000 | 0.001 | -0.022 | 0.008 | 0.001 | -0.133 | 0.001 | 0.009 | 0.004 | -0.025 | 0.000 | 0.008 | 0.011 | 0.005 | -0.038 |
| Give_Way | 0.006 | 0.005 | 0.058 | 0.000 | 0.001 | 1.000 | 0.005 | 0.009 | 0.006 | 0.008 | 0.003 | 0.009 | 0.031 | 0.004 | 0.003 | 0.072 | 0.007 | 0.010 | 0.000 |
| Humidity(%) | 0.015 | 0.242 | 0.035 | -0.019 | -0.022 | 0.005 | 1.000 | 0.010 | 0.009 | 0.057 | 0.006 | 0.028 | 0.026 | -0.331 | 0.005 | 0.020 | -0.465 | 0.088 | -0.198 |
| Junction | 0.026 | 0.016 | 0.088 | 0.001 | 0.008 | 0.009 | 0.010 | 1.000 | 0.004 | 0.027 | 0.009 | 0.053 | 0.037 | 0.021 | 0.005 | 0.105 | 0.004 | 0.030 | 0.000 |
| No_Exit | 0.014 | 0.005 | 0.061 | 0.000 | 0.001 | 0.006 | 0.009 | 0.004 | 1.000 | 0.007 | 0.004 | 0.012 | 0.026 | 0.006 | 0.012 | 0.030 | 0.007 | 0.006 | 0.000 |
| Pressure(in) | 0.023 | 0.030 | 0.035 | -0.125 | -0.133 | 0.008 | 0.057 | 0.027 | 0.007 | 1.000 | 0.016 | 0.046 | 0.002 | -0.004 | 0.005 | 0.037 | 0.067 | 0.089 | -0.000 |
| Railway | 0.050 | 0.000 | 0.178 | 0.000 | 0.001 | 0.003 | 0.006 | 0.009 | 0.004 | 0.016 | 1.000 | 0.012 | 0.007 | 0.010 | 0.005 | 0.058 | 0.003 | 0.008 | 0.000 |
| Severity | 0.039 | 0.055 | 0.121 | 0.006 | 0.009 | 0.009 | 0.028 | 0.053 | 0.012 | 0.046 | 0.012 | 1.000 | 0.060 | 0.035 | 0.006 | 0.121 | 0.012 | 0.109 | 0.001 |
| Stop | 0.034 | 0.001 | 0.116 | 0.001 | 0.004 | 0.031 | 0.026 | 0.037 | 0.026 | 0.002 | 0.007 | 0.060 | 1.000 | 0.015 | 0.026 | 0.048 | 0.001 | 0.009 | 0.000 |
| Temperature(F) | 0.011 | 0.264 | 0.051 | -0.058 | -0.025 | 0.004 | -0.331 | 0.021 | 0.006 | -0.004 | 0.010 | 0.035 | 0.015 | 1.000 | 0.005 | 0.044 | 0.224 | 0.077 | 0.088 |
| Traffic_Calming | 0.024 | 0.000 | 0.038 | 0.001 | 0.000 | 0.003 | 0.005 | 0.005 | 0.012 | 0.005 | 0.005 | 0.006 | 0.026 | 0.005 | 1.000 | 0.012 | 0.001 | 0.006 | 0.000 |
| Traffic_Signal | 0.106 | 0.045 | 0.477 | 0.004 | 0.008 | 0.072 | 0.020 | 0.105 | 0.030 | 0.037 | 0.058 | 0.121 | 0.048 | 0.044 | 0.012 | 1.000 | 0.003 | 0.075 | 0.001 |
| Visibility(mi) | 0.002 | 0.016 | 0.007 | -0.009 | 0.011 | 0.007 | -0.465 | 0.004 | 0.007 | 0.067 | 0.003 | 0.012 | 0.001 | 0.224 | 0.001 | 0.003 | 1.000 | 0.011 | 0.055 |
| Wind_Direction | 0.023 | 0.181 | 0.052 | 0.001 | 0.005 | 0.010 | 0.088 | 0.030 | 0.006 | 0.089 | 0.008 | 0.109 | 0.009 | 0.077 | 0.006 | 0.075 | 0.011 | 1.000 | 0.002 |
| Wind_Speed(mph) | 0.000 | 0.001 | 0.001 | -0.005 | -0.038 | 0.000 | -0.198 | 0.000 | 0.000 | -0.000 | 0.000 | 0.001 | 0.000 | 0.088 | 0.000 | 0.001 | 0.055 | 0.002 | 1.000 |
Missing values
Sample
| Severity | Distance(mi) | Street | Zipcode | Temperature(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Weather_Condition | Amenity | Crossing | Give_Way | Junction | No_Exit | Railway | Stop | Traffic_Calming | Traffic_Signal | Civil_Twilight | Duration_Seconds | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3 | 0.01 | I-70 E | 45424 | 36.9 | 91.0 | 29.68 | 10.0 | Calm | NaN | Light Rain | False | False | False | False | False | False | False | False | False | Night | 18840.0 |
| 1 | 2 | 0.01 | Brice Rd | 43068-3402 | 37.9 | 100.0 | 29.65 | 10.0 | Calm | NaN | Light Rain | False | False | False | False | False | False | False | False | False | Night | 1800.0 |
| 2 | 2 | 0.01 | State Route 32 | 45176 | 36.0 | 100.0 | 29.67 | 10.0 | SW | 3.5 | Overcast | False | False | False | False | False | False | False | False | True | Night | 1800.0 |
| 3 | 3 | 0.01 | I-75 S | 45417 | 35.1 | 96.0 | 29.64 | 9.0 | SW | 4.6 | Mostly Cloudy | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 4 | 2 | 0.01 | Miamisburg Centerville Rd | 45459 | 36.0 | 89.0 | 29.65 | 6.0 | SW | 3.5 | Mostly Cloudy | False | False | False | False | False | False | False | False | True | Day | 1800.0 |
| 5 | 3 | 0.01 | Westerville Rd | 43081 | 37.9 | 97.0 | 29.63 | 7.0 | SSW | 3.5 | Light Rain | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 6 | 2 | 0.00 | N Woodward Ave | 45417-2476 | 34.0 | 100.0 | 29.66 | 7.0 | WSW | 3.5 | Overcast | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 7 | 3 | 0.01 | N Main St | 45405 | 34.0 | 100.0 | 29.66 | 7.0 | WSW | 3.5 | Overcast | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 8 | 2 | 0.00 | Notre Dame Ave | 45404-1923 | 33.3 | 99.0 | 29.67 | 5.0 | SW | 1.2 | Mostly Cloudy | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 9 | 3 | 0.01 | Westerville Rd | 43081 | 37.4 | 100.0 | 29.62 | 3.0 | SSW | 4.6 | Light Rain | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| Severity | Distance(mi) | Street | Zipcode | Temperature(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Weather_Condition | Amenity | Crossing | Give_Way | Junction | No_Exit | Railway | Stop | Traffic_Calming | Traffic_Signal | Civil_Twilight | Duration_Seconds | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7728384 | 2 | 0.390 | I-10 E | 91706 | 78.0 | 52.0 | 29.69 | 10.0 | VAR | 6.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1723.0 |
| 7728385 | 2 | 0.000 | CA-60 E | 92555 | 88.0 | 32.0 | 28.20 | 10.0 | WNW | 10.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1703.0 |
| 7728386 | 2 | 0.189 | El Camino Real N | 93003 | 73.0 | 68.0 | 29.76 | 10.0 | W | 9.0 | Fair | False | False | False | True | False | False | False | False | False | Day | 1703.0 |
| 7728387 | 2 | 0.443 | Santa Ana Fwy S | 92780 | 75.0 | 60.0 | 29.74 | 10.0 | SSW | 9.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1711.0 |
| 7728388 | 2 | 0.000 | Golden State Fwy N | 91331 | 81.0 | 48.0 | 28.78 | 10.0 | ESE | 6.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1711.0 |
| 7728389 | 2 | 0.543 | Pomona Fwy E | 92501 | 86.0 | 40.0 | 28.92 | 10.0 | W | 13.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1716.0 |
| 7728390 | 2 | 0.338 | I-8 W | 92108 | 70.0 | 73.0 | 29.39 | 10.0 | SW | 6.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1613.0 |
| 7728391 | 2 | 0.561 | Garden Grove Fwy | 92866 | 73.0 | 64.0 | 29.74 | 10.0 | SSW | 10.0 | Partly Cloudy | False | False | False | True | False | False | False | False | False | Day | 1708.0 |
| 7728392 | 2 | 0.772 | San Diego Fwy S | 90230 | 71.0 | 81.0 | 29.62 | 10.0 | SW | 8.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1761.0 |
| 7728393 | 2 | 0.537 | CA-210 W | 92346 | 79.0 | 47.0 | 28.63 | 7.0 | SW | 7.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1765.0 |
Duplicate rows
Most frequently occurring
| Severity | Distance(mi) | Street | Zipcode | Temperature(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Weather_Condition | Amenity | Crossing | Give_Way | Junction | No_Exit | Railway | Stop | Traffic_Calming | Traffic_Signal | Civil_Twilight | Duration_Seconds | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92015 | 2 | 0.521 | Foothill Fwy W | 91106 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | False | False | False | False | False | False | False | False | Day | 21600.0 | 36 |
| 78117 | 2 | 0.296 | US-169 S | 66203 | NaN | NaN | NaN | NaN | North | NaN | NaN | False | False | False | False | False | False | False | False | False | Day | 21600.0 | 34 |
| 86352 | 2 | 0.421 | I-35 N | 66103 | NaN | NaN | NaN | NaN | North | NaN | NaN | False | False | False | True | False | False | False | False | False | Day | 21600.0 | 31 |
| 67324 | 2 | 0.181 | I-35 N | 66203 | NaN | NaN | NaN | NaN | North | NaN | NaN | False | False | False | False | False | False | False | False | False | Day | 21600.0 | 29 |
| 72230 | 2 | 0.229 | Lee Hwy | 22031-2318 | 46.6 | 68.0 | 30.36 | 10.0 | WSW | 5.8 | Clear | False | True | False | False | False | False | False | False | False | Day | 3389400.0 | 28 |
| 85262 | 2 | 0.403 | I-35 S | 66203 | NaN | NaN | NaN | NaN | North | NaN | NaN | False | False | False | True | False | False | False | False | False | Day | 21600.0 | 26 |
| 92150 | 2 | 0.524 | CA-134 E | 91101 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | False | False | False | False | False | False | False | False | Day | 21600.0 | 26 |
| 85504 | 2 | 0.407 | US-169 S | 66203 | NaN | NaN | NaN | NaN | North | NaN | NaN | False | False | False | True | False | False | False | False | False | Day | 21600.0 | 24 |
| 53680 | 2 | 0.095 | N Highway 97 | 97703 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | False | False | True | False | False | False | False | False | Night | 14400.0 | 19 |
| 133125 | 2 | 3.768 | Richmond-San Rafael Brg | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | False | False | False | False | False | False | False | False | Day | 21600.0 | 19 |